package com.dingding.special.order.confirm.sql;

/**
 * 
 * @ClassName: ConfirmArriveSQL 
 * @Description: 确认到达SQL
 * @author YHQ
 * @date 2016年8月21日 下午6:53:44
 * @since V2.4.0
 * 
 */
public class ConfirmArriveSQL {

	/**
	 * 确认到达，获取通知消息
	 */
	public static String GET_CONFIRM_ARRIVE_NOTICE_INFO = "SELECT u.distance,u.specialOrderId as oid,u.orderStatus,u.publishType,u.totalMoney,ul.aliasId,ul.loginEquipment FROM userspecialordert u INNER JOIN userlogin ul ON u.placeOrderUserId = ul.uid WHERE u.specialOrderId = ?";
	
}
